Pandas Profiling Report

Dataset statistics

Number of variables	41
Number of observations	70372
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	22.0 MiB
Average record size in memory	328.0 B

Variable types

BOOL	29
NUM	9
DATE	3

Warnings

`tot_contribution_paid_amt` is highly skewed (γ1 = 69.13668969)	Skewed
`Lifetime Giving` is highly skewed (γ1 = 30.32802605)	Skewed
`tot_ticket_paid_amt` has 953 (1.4%) zeros	Zeros
`tot_contribution_paid_amt` has 68563 (97.4%) zeros	Zeros
`Prelim Capacity` has 30829 (43.8%) zeros	Zeros
`Lifetime Giving` has 58829 (83.6%) zeros	Zeros
`days_to_donation` has 58782 (83.5%) zeros	Zeros

Reproduction

Analysis started	2020-09-08 20:03:36.337975
Analysis finished	2020-09-08 20:04:59.267828
Duration	1 minute and 22.93 seconds
Software version	pandas-profiling v2.9.0
Download configuration	config.yaml

owner_no
Real number (ℝ_≥0)

Distinct	38522
Distinct (%)	54.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	2022525.081
Minimum	111
Maximum	2419301
Zeros	0
Zeros (%)	0.0%
Memory size	549.8 KiB

Quantile statistics

Minimum	111
5-th percentile	397258.05
Q1	1928112
median	2370216.5
Q3	2391456
95-th percentile	2413551.9
Maximum	2419301
Range	2419190
Interquartile range (IQR)	463344

Descriptive statistics

Standard deviation	629695.9448
Coefficient of variation (CV)	0.3113414765
Kurtosis	2.187826958
Mean	2022525.081
Median Absolute Deviation (MAD)	40994.5
Skewness	-1.835938465
Sum	1.42329135e+11
Variance	3.965169829e+11
Monotocity	Increasing

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2335299	66	0.1%
1485790	64	0.1%
275098	48	0.1%
2289267	47	0.1%
2373627	47	0.1%
2140595	46	0.1%
2133270	44	0.1%
2375331	43	0.1%
2388599	43	0.1%
2387926	42	0.1%
Other values (38512)	69882	99.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
111	3	< 0.1%
258	1	< 0.1%
262	2	< 0.1%
267	5	< 0.1%
853	3	< 0.1%

Value	Count	Frequency (%)
2419301	1	< 0.1%
2419278	1	< 0.1%
2419248	1	< 0.1%
2419126	1	< 0.1%
2419011	1	< 0.1%

order_dt
Date

Distinct	2160
Distinct (%)	3.1%
Missing	0
Missing (%)	0.0%
Memory size	549.8 KiB

Minimum	2014-01-01 00:00:00
Maximum	2020-02-29 00:00:00

Histogram

Histogram with fixed size bins (bins=50)

tot_ticket_paid_amt
Real number (ℝ)

ZEROS

Distinct	1159
Distinct (%)	1.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	0.5573702184
Minimum	-0.1276523274
Maximum	34.33847607
Zeros	953
Zeros (%)	1.4%
Memory size	549.8 KiB

Quantile statistics

Minimum	-0.1276523274
5-th percentile	-0.1276523274
Q1	-0.1276523274
median	0
Q3	0.8723476726
95-th percentile	2.629637945
Maximum	34.33847607
Range	34.4661284
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	1.262070333
Coefficient of variation (CV)	2.264330405
Kurtosis	64.08996281
Mean	0.5573702184
Median Absolute Deviation (MAD)	0.1276523274
Skewness	5.40552422
Sum	39223.25701
Variance	1.592821524
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-0.1276523274	34085	48.4%
0.1276523274	1032	1.5%
0	953	1.4%
1.136105714	793	1.1%
0.1148870947	761	1.1%
0.7531487317	714	1.0%
1.391410369	695	1.0%
0.2553046548	675	1.0%
0.5106093097	659	0.9%
0.1914784911	633	0.9%
Other values (1149)	29372	41.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-0.1276523274	34085	48.4%
-0.121269711	1	< 0.1%
-0.1148870947	4	< 0.1%
-0.1085044783	1	< 0.1%
-0.1021218619	14	< 0.1%

Value	Count	Frequency (%)
34.33847607	1	< 0.1%
32.93430047	1	< 0.1%
29.15579158	1	< 0.1%
28.04521633	1	< 0.1%
27.26653714	1	< 0.1%

tot_contribution_paid_amt
Real number (ℝ_≥0)

SKEWED
ZEROS

Distinct	131
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	2.020798045
Minimum	0
Maximum	5000
Zeros	68563
Zeros (%)	97.4%
Memory size	549.8 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	0
Maximum	5000
Range	5000
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	42.71554863
Coefficient of variation (CV)	21.1379602
Kurtosis	6497.137924
Mean	2.020798045
Median Absolute Deviation (MAD)	0
Skewness	69.13668969
Sum	142207.6
Variance	1824.618095
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	68563	97.4%
100	334	0.5%
10	217	0.3%
25	183	0.3%
50	128	0.2%
20	125	0.2%
5	97	0.1%
40	76	0.1%
2	47	0.1%
250	32	< 0.1%
Other values (121)	570	0.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	68563	97.4%
1	21	< 0.1%
1.5	1	< 0.1%
2	47	0.1%
2.2	3	< 0.1%

Value	Count	Frequency (%)
5000	2	< 0.1%
2500	5	< 0.1%
2250	1	< 0.1%
2000	2	< 0.1%
1500	1	< 0.1%

first_order_dt
Date

Distinct	2931
Distinct (%)	4.2%
Missing	0
Missing (%)	0.0%
Memory size	549.8 KiB

Minimum	2010-01-10 00:00:00
Maximum	2020-02-29 00:00:00

Histogram

Histogram with fixed size bins (bins=50)

first_cont_dt
Date

Distinct	1398
Distinct (%)	2.0%
Missing	0
Missing (%)	0.0%
Memory size	549.8 KiB

Minimum	1900-01-01 00:00:00
Maximum	2020-08-20 00:00:00

Histogram

Histogram with fixed size bins (bins=50)

geo_area_desc
Real number (ℝ_≥0)

Distinct	7
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	1.674103337
Minimum	1
Maximum	7
Zeros	0
Zeros (%)	0.0%
Memory size	549.8 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
median	1
Q3	2
95-th percentile	6
Maximum	7
Range	6
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	1.497853338
Coefficient of variation (CV)	0.8947197612
Kurtosis	5.987047599
Mean	1.674103337
Median Absolute Deviation (MAD)	0
Skewness	2.620774255
Sum	117810
Variance	2.243564621
Monotocity	Not monotonic

Histogram with fixed size bins (bins=7)

Value	Count	Frequency (%)
1	51168	72.7%
2	10277	14.6%
7	3473	4.9%
3	2428	3.5%
5	1503	2.1%
4	1080	1.5%
6	443	0.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	51168	72.7%
2	10277	14.6%
3	2428	3.5%
4	1080	1.5%
5	1503	2.1%

Value	Count	Frequency (%)
7	3473	4.9%
6	443	0.6%
5	1503	2.1%
4	1080	1.5%
3	2428	3.5%

Prelim Capacity
Real number (ℝ_≥0)

ZEROS

Distinct	11
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	1.910319445
Minimum	0
Maximum	10
Zeros	30829
Zeros (%)	43.8%
Memory size	549.8 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	2
Q3	4
95-th percentile	5
Maximum	10
Range	10
Interquartile range (IQR)	4

Descriptive statistics

Standard deviation	1.946138595
Coefficient of variation (CV)	1.018750345
Kurtosis	-1.09127187
Mean	1.910319445
Median Absolute Deviation (MAD)	2
Skewness	0.4400920866
Sum	134433
Variance	3.787455429
Monotocity	Not monotonic

Histogram with fixed size bins (bins=11)

Value	Count	Frequency (%)
0	30829	43.8%
4	11622	16.5%
3	11043	15.7%
2	6672	9.5%
5	5271	7.5%
1	2997	4.3%
6	1611	2.3%
7	181	0.3%
8	130	0.2%
9	13	< 0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	30829	43.8%
1	2997	4.3%
2	6672	9.5%
3	11043	15.7%
4	11622	16.5%

Value	Count	Frequency (%)
10	3	< 0.1%
9	13	< 0.1%
8	130	0.2%
7	181	0.3%
6	1611	2.3%

ltv_tkt_value
Real number (ℝ)

Distinct	2560
Distinct (%)	3.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	1.201675607
Minimum	-0.2779850746
Maximum	78.66231343
Zeros	59
Zeros (%)	0.1%
Memory size	549.8 KiB

Quantile statistics

Minimum	-0.2779850746
5-th percentile	-0.2779850746
Q1	-0.2779850746
median	0
Q3	0.7220149254
95-th percentile	6.699626866
Maximum	78.66231343
Range	78.94029851
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	4.525258255
Coefficient of variation (CV)	3.765790224
Kurtosis	94.91915165
Mean	1.201675607
Median Absolute Deviation (MAD)	0.2779850746
Skewness	8.256546927
Sum	84564.31584
Variance	20.47796228
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-0.2779850746	21484	30.5%
-0.203358209	782	1.1%
-0.2406716418	758	1.1%
-0.1660447761	564	0.8%
-0.2070895522	500	0.7%
-0.02052238806	492	0.7%
0.1660447761	476	0.7%
0.09141791045	464	0.7%
-0.1324626866	452	0.6%
-0.0578358209	430	0.6%
Other values (2550)	43970	62.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-0.2779850746	21484	30.5%
-0.2742537313	2	< 0.1%
-0.2705223881	13	< 0.1%
-0.2686567164	7	< 0.1%
-0.2667910448	1	< 0.1%

Value	Count	Frequency (%)
78.66231343	31	< 0.1%
61.79477612	33	< 0.1%
57.22014925	64	0.1%
55.68656716	31	< 0.1%
39.14552239	17	< 0.1%

Lifetime Giving
Real number (ℝ_≥0)

SKEWED
ZEROS

Distinct	584
Distinct (%)	0.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	4568.75912
Minimum	0
Maximum	3417602
Zeros	58829
Zeros (%)	83.6%
Memory size	549.8 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	490
Maximum	3417602
Range	3417602
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	106920.769
Coefficient of variation (CV)	23.40258399
Kurtosis	951.2318377
Mean	4568.75912
Median Absolute Deviation (MAD)	0
Skewness	30.32802605
Sum	321512716.8
Variance	1.143205085e+10
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	58829	83.6%
100	792	1.1%
25	673	1.0%
10	488	0.7%
50	465	0.7%
20	266	0.4%
200	264	0.4%
5	204	0.3%
250	193	0.3%
40	161	0.2%
Other values (574)	8037	11.4%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	58829	83.6%
1	38	0.1%
1.25	2	< 0.1%
1.37	4	< 0.1%
2	92	0.1%

Value	Count	Frequency (%)
3417602	64	0.1%
2061042	3	< 0.1%
1042301	31	< 0.1%
461460.08	15	< 0.1%
357601	16	< 0.1%

prospect_board
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	549.8 KiB

0	69057
1	1315

Common Values
Chart

Value	Count	Frequency (%)
0	69057	98.1%
1	1315	1.9%

days_to_donation
Real number (ℝ_≥0)

ZEROS

Distinct	1172
Distinct (%)	1.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	152.239925
Minimum	0
Maximum	3847
Zeros	58782
Zeros (%)	83.5%
Memory size	549.8 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	1208
Maximum	3847
Range	3847
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	490.9563657
Coefficient of variation (CV)	3.224885757
Kurtosis	17.90792151
Mean	152.239925
Median Absolute Deviation (MAD)	0
Skewness	4.0617276
Sum	10713428
Variance	241038.153
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	58782	83.5%
100	1248	1.8%
99	787	1.1%
1606	66	0.1%
277	64	0.1%
101	58	0.1%
253	52	0.1%
704	50	0.1%
209	49	0.1%
920	48	0.1%
Other values (1162)	9168	13.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	58782	83.5%
99	787	1.1%
100	1248	1.8%
101	58	0.1%
102	14	< 0.1%

Value	Count	Frequency (%)
3847	25	< 0.1%
3823	6	< 0.1%
3816	7	< 0.1%
3794	1	< 0.1%
3783	13	< 0.1%

first_cont_order
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	549.8 KiB

0	69124
1	1248

Common Values
Chart

Value	Count	Frequency (%)
0	69124	98.2%
1	1248	1.8%

first_cont_after
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	549.8 KiB

0	60817
1	9555

Common Values
Chart

Value	Count	Frequency (%)
0	60817	86.4%
1	9555	13.6%

rolling_tkt_sum
Real number (ℝ)

Distinct	4868
Distinct (%)	6.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%

Mean	2.345111923
Minimum	-0.2580645161
Maximum	495.5225806
Zeros	407
Zeros (%)	0.6%
Memory size	549.8 KiB

Quantile statistics

Minimum	-0.2580645161
5-th percentile	-0.2580645161
Q1	-0.2580645161
median	0
Q3	0.7419354839
95-th percentile	9.575322581
Maximum	495.5225806
Range	495.7806452
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	13.53092567
Coefficient of variation (CV)	5.769842174
Kurtosis	426.3247918
Mean	2.345111923
Median Absolute Deviation (MAD)	0.2580645161
Skewness	17.04718958
Sum	165030.2162
Variance	183.0859496
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-0.2580645161	26312	37.4%
-0.1290322581	852	1.2%
-0.1935483871	754	1.1%
-0.135483871	715	1.0%
0.1870967742	658	0.9%
0.5096774194	621	0.9%
0.3806451613	601	0.9%
-0.006451612903	564	0.8%
-0.06451612903	550	0.8%
0.5741935484	462	0.7%
Other values (4858)	38283	54.4%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-0.2580645161	26312	37.4%
-0.2516129032	3	< 0.1%
-0.2451612903	11	< 0.1%
-0.2419354839	7	< 0.1%
-0.2387096774	1	< 0.1%

Value	Count	Frequency (%)
495.5225806	2	< 0.1%
493.0322581	1	< 0.1%
452.3870968	2	< 0.1%
451.6129032	4	< 0.1%
451.2903226	1	< 0.1%

channel_desc_3rd Party
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	549.8 KiB

0	67715
1	2657

Common Values
Chart

Value	Count	Frequency (%)
0	67715	96.2%
1	2657	3.8%

channel_desc_At the Performance
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	549.8 KiB

0	70169
1	203

Common Values
Chart

Value	Count	Frequency (%)
0	70169	99.7%
1	203	0.3%

channel_desc_Chat
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	549.8 KiB

0	70178
1	194

Common Values
Chart

Value	Count	Frequency (%)
0	70178	99.7%
1	194	0.3%

channel_desc_Default Channel
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	549.8 KiB

0	63212
1	7160

Common Values
Chart

Value	Count	Frequency (%)
0	63212	89.8%
1	7160	10.2%

channel_desc_Email
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	549.8 KiB

0	68361
1	2011

Common Values
Chart

Value	Count	Frequency (%)
0	68361	97.1%
1	2011	2.9%

channel_desc_Fax
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	549.8 KiB

0	70358
1	14

Common Values
Chart

Value	Count	Frequency (%)
0	70358	> 99.9%
1	14	< 0.1%

channel_desc_Internal Request
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	549.8 KiB

0	64861
1	5511

Common Values
Chart

Value	Count	Frequency (%)
0	64861	92.2%
1	5511	7.8%

channel_desc_Mail
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	549.8 KiB

0	70039
1	333

Common Values
Chart

Value	Count	Frequency (%)
0	70039	99.5%
1	333	0.5%

channel_desc_Mobile
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	549.8 KiB

0	62036
1	8336

Common Values
Chart

Value	Count	Frequency (%)
0	62036	88.2%
1	8336	11.8%

channel_desc_Online
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	549.8 KiB

1	35256
0	35116

Common Values
Chart

Value	Count	Frequency (%)
1	35256	50.1%
0	35116	49.9%

channel_desc_Phone
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	549.8 KiB

0	61875
1	8497

Common Values
Chart

Value	Count	Frequency (%)
0	61875	87.9%
1	8497	12.1%

channel_desc_Telefunding
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	549.8 KiB

0	70371
1	1

Common Values
Chart

Value	Count	Frequency (%)
0	70371	> 99.9%
1	1	< 0.1%

channel_desc_Walk Up
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	549.8 KiB

0	69808
1	564

Common Values
Chart

Value	Count	Frequency (%)
0	69808	99.2%
1	564	0.8%

MOS_desc_External
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	549.8 KiB

0	59247
1	11125

Common Values
Chart

Value	Count	Frequency (%)
0	59247	84.2%
1	11125	15.8%

MOS_desc_Internal
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	549.8 KiB

1	41201
0	29171

Common Values
Chart

Value	Count	Frequency (%)
1	41201	58.5%
0	29171	41.5%

MOS_desc_Ticketing
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	549.8 KiB

0	52118
1	18254

Common Values
Chart

Value	Count	Frequency (%)
0	52118	74.1%
1	18254	25.9%

delivery_desc_Digital
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	549.8 KiB

1	43240
0	27132

Common Values
Chart

Value	Count	Frequency (%)
1	43240	61.4%
0	27132	38.6%

delivery_desc_Do Not Print Tickets
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	549.8 KiB

0	69424
1	948

Common Values
Chart

Value	Count	Frequency (%)
0	69424	98.7%
1	948	1.3%

delivery_desc_Mail
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	549.8 KiB

0	59870
1	10502

Common Values
Chart

Value	Count	Frequency (%)
0	59870	85.1%
1	10502	14.9%

delivery_desc_Will Call
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	549.8 KiB

0	54426
1	15946

Common Values
Chart

Value	Count	Frequency (%)
0	54426	77.3%
1	15946	22.7%

facility_desc_Academy of Music
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	549.8 KiB

1	38198
0	32174

Common Values
Chart

Value	Count	Frequency (%)
1	38198	54.3%
0	32174	45.7%

facility_desc_Fundraiser
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	549.8 KiB

0	68456
1	1916

Common Values
Chart

Value	Count	Frequency (%)
0	68456	97.3%
1	1916	2.7%

facility_desc_Independence Mall
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	549.8 KiB

0	48723
1	21649

Common Values
Chart

Value	Count	Frequency (%)
0	48723	69.2%
1	21649	30.8%

facility_desc_Other
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	549.8 KiB

0	68507
1	1865

Common Values
Chart

Value	Count	Frequency (%)
0	68507	97.3%
1	1865	2.7%

facility_desc_Perelman
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	549.8 KiB

0	62351
1	8021

Common Values
Chart

Value	Count	Frequency (%)
0	62351	88.6%
1	8021	11.4%

facility_desc_Small venue
Boolean

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	549.8 KiB

0	66278
1	4094

Common Values
Chart

Value	Count	Frequency (%)
0	66278	94.2%
1	4094	5.8%

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Count
Matrix

First rows

	owner_no	order_dt	tot_ticket_paid_amt	first_order_dt	first_cont_dt	geo_area_desc	Prelim Capacity	ltv_tkt_value	rolling_tkt_sum	channel_desc_3rd Party	channel_desc_Default Channel	channel_desc_Internal Request	channel_desc_Online	channel_desc_Phone	MOS_desc_External	MOS_desc_Internal	MOS_desc_Ticketing	delivery_desc_Digital	delivery_desc_Mail	delivery_desc_Will Call	facility_desc_Academy of Music	facility_desc_Fundraiser	facility_desc_Small venue
0	111	2015-10-07	0.753149	2015-10-07	1900-01-01	1	5	0.404851	0.187097	0	1	0	0	0	1	0	0	0	0	1	1	0	0
1	111	2016-09-16	0.880801	2015-10-07	1900-01-01	1	5	0.404851	0.696774	0	0	0	0	1	0	0	1	0	0	1	1	0	0
2	111	2018-09-21	0.319131	2015-10-07	1900-01-01	1	5	0.404851	0.922581	1	0	0	0	0	1	0	0	0	0	1	1	0	0
3	258	2014-09-28	0.951010	2014-09-28	1900-01-01	5	6	0.037313	0.287097	0	1	0	0	0	1	0	0	0	0	1	1	0	0
4	262	2014-10-02	0.159565	2014-10-02	1900-01-01	2	4	-0.110075	0.177419	0	0	0	0	1	0	0	1	0	0	1	1	0	0
5	262	2015-03-17	0.159565	2014-10-02	1900-01-01	2	4	-0.110075	0.612903	0	0	0	0	1	0	0	1	0	1	0	1	0	0
6	267	2015-04-16	-0.127652	2015-04-16	1900-01-01	1	6	3.039179	-0.258065	0	0	1	0	0	0	0	1	0	0	1	1	0	0
7	267	2016-04-13	1.774367	2015-04-16	1900-01-01	1	6	3.039179	0.703226	0	0	0	1	0	0	1	0	0	1	0	1	0	0
8	267	2016-05-03	-0.127652	2015-04-16	1900-01-01	1	6	3.039179	-0.258065	0	0	1	0	0	0	0	1	0	0	1	0	1	0
9	267	2018-05-09	8.808011	2015-04-16	1900-01-01	1	6	3.039179	5.219355	0	0	0	1	0	0	1	0	1	0	0	0	0	1

Last rows

	owner_no	order_dt	tot_ticket_paid_amt	tot_contribution_paid_amt	first_order_dt	first_cont_dt	geo_area_desc	Prelim Capacity	ltv_tkt_value	Lifetime Giving	days_to_donation	first_cont_order	first_cont_after	rolling_tkt_sum	channel_desc_Default Channel	channel_desc_Internal Request	channel_desc_Online	channel_desc_Phone	MOS_desc_External	MOS_desc_Internal	MOS_desc_Ticketing	delivery_desc_Digital	delivery_desc_Mail	delivery_desc_Will Call	facility_desc_Academy of Music	facility_desc_Fundraiser	facility_desc_Independence Mall	facility_desc_Perelman
70362	2418866	2016-02-08	0.446783	0.0	2012-10-04	2020-04-20	7	1	-0.110075	25.0	2855.0	0	1	0.032258	0	0	1	0	0	1	0	1	0	0	1	0	0	0
70363	2418866	2016-02-12	-0.127652	0.0	2012-10-04	2020-04-20	7	1	-0.110075	25.0	2855.0	0	1	-0.258065	0	1	0	0	0	0	1	0	0	1	0	1	0	0
70364	2418931	2018-04-25	1.404176	0.0	2018-04-25	2020-05-05	2	5	0.169776	100.0	841.0	0	1	0.516129	0	0	1	0	0	1	0	1	0	0	1	0	0	0
70365	2418999	2016-10-01	-0.127652	20.0	2016-10-01	2016-10-01	1	3	-0.046642	20.0	100.0	1	0	-0.258065	0	0	1	0	0	1	0	1	0	0	0	0	1	0
70366	2418999	2017-02-13	0.663792	0.0	2016-10-01	2016-10-01	1	3	-0.046642	20.0	100.0	1	0	0.141935	0	0	1	0	0	1	0	1	0	0	1	0	0	0
70367	2419011	2018-09-07	-0.127652	25.0	2018-09-07	2018-09-07	2	5	-0.277985	50.0	100.0	1	0	-0.258065	0	0	1	0	0	1	0	1	0	0	0	0	1	0
70368	2419126	2019-09-19	-0.127652	0.0	2019-09-19	1900-01-01	1	0	0.841418	0.0	0.0	0	0	-0.258065	0	1	0	0	0	0	1	0	0	1	1	0	0	0
70369	2419248	2017-09-20	2.680699	0.0	2017-09-20	2019-12-11	2	4	0.542910	100.0	912.0	0	1	1.161290	0	0	0	1	0	0	1	1	0	0	1	0	0	0
70370	2419278	2015-04-13	2.393481	0.0	2011-04-03	2003-03-26	1	3	1.125000	75.0	99.0	0	0	1.016129	1	0	0	0	1	0	0	0	1	0	1	0	0	0
70371	2419301	2018-01-18	0.638262	0.0	2018-01-18	1900-01-01	1	0	-0.054104	0.0	0.0	0	0	0.129032	0	0	1	0	0	1	0	0	1	0	0	0	0	1

Overview

Variables

Interactions

Correlations

Pearson's r

Spearman's ρ

Kendall's τ

Phik (φk)

Missing values

Sample

First rows

Last rows